package com.unionx.unionxuf.localdao;

import java.util.List;

import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import com.unionx.unionxuf.common.Prams;
import com.unionx.unionxuf.entity.BillSub;
import com.unionx.unionxuf.entity.BillSubInfoDTD;
import com.unionx.unionxuf.entity.ComBill2;
import com.unionx.unionxuf.entity.CropDTD;
@Repository
public interface BillSubMapper {
    int deleteByPrimaryKey(Integer id);
  
    int insert(BillSub record);

    int insertSelective(BillSub record);

    BillSub selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(BillSub record);

    int updateByPrimaryKey(BillSub record);
    
    List<BillSub> getProbyLsandCid(CropDTD c);

    @Select("select price_after_discount from billsub where cropid = #{0} and serialno = #{1}")
    List<String>  get(String cropid, String serialno);

	List<BillSub> getcusinfo(Prams p);

	List<BillSub> selectByls(CropDTD dtd);

	int updateCtype(BillSub bs);

	

	List<BillSub> selectaa(CropDTD dtd);

	List<BillSub> getAllBillSub(String cropid);

	List<BillSub> getAllBillSub(ComBill2 cbs);

	List<BillSub> getByLsh(String string);

	int deletebycidandlsh(CropDTD c);

	List<BillSub> selectAll();

	List<BillSub> selectAll(String cropid);

	List<BillSub> selectBillSub(CropDTD c);

	int updateCtype2(BillSub bs);


}